CREATE TABLE `${tableTop}${tableName}` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
<#list columns as item>
<#if attrTypes[item_index] == "Integer">
`${item.column}` int(<#if attrLengths[item_index]??>${attrLengths[item_index]}<#else>11</#if>) NOT NULL COMMENT '${attrRemarks[item_index]}',
<#elseif attrTypes[item_index] == "String">
`${item.column}` varchar(<#if attrLengths[item_index]??>${attrLengths[item_index]}<#else>255</#if>) NOT NULL COMMENT '${attrRemarks[item_index]}',
<#elseif attrTypes[item_index] == "Date">
`${item.column}` datetime NOT NULL COMMENT '${attrRemarks[item_index]}',
<#elseif attrTypes[item_index] == "Long">
`${item.column}` bigint(<#if attrLengths[item_index]??>${attrLengths[item_index]}<#else>20</#if>) NOT NULL COMMENT '${attrRemarks[item_index]}',
<#elseif attrTypes[item_index] == "BigDecimal">
`${item.column}` decimal(<#if attrLengths[item_index]??>${attrLengths[item_index]}<#else>10,0</#if>) NOT NULL COMMENT '${attrRemarks[item_index]}',
</#if>
</#list>
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8;